﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using WebScrapper.Helpers;
//using WebScrapper.Entities;
using WebScrapper.Entities.AlternateFlow;
using CarlosAg.ExcelXmlWriter;
using System.IO;
using System.Windows.Forms;
using App.Core.Extensions;
using System.Data;
using App.Core.DB;


namespace WebScrapper.Implementations.ZukaBuka
{
    public class JuvedermUltra : BaseImplementation<App.Core.Base.Model.BaseEntity>
    {
        /// <summary>
        /// Sample URL Format: 'http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=8862&sessionid=7f002d85-8378-4705-9fb2-9866414147de&radius=40&lat=51.5001524&lon=-0.1262362&treatmenttype=facial&pagenum={0}&mode=p&postal=London'
        /// </summary>
        private String URLFormat { get; set; }
        //private int _UrlCount = 0;
        private List<offices> _ExtractedOffices = new List<offices>();

        #region URLs of Ireland
        /// <summary>
        /// Urls for Ireland Site
        /// </summary>
        //private String [] _URLs = {"http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=3373&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.7133822&lon=-6.216760900000054&treatmenttype=facial&pagenum={0}&mode=p&postal=Antrim",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=6603&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.3475392&lon=-6.656108200000062&treatmenttype=facial&pagenum={0}&mode=p&postal=Armagh",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=4557&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.7518736&lon=-6.002596600000061&treatmenttype=facial&pagenum={0}&mode=p&postal=Ballyvlare",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=9353&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.8631169&lon=-6.27834299999995&treatmenttype=facial&pagenum={0}&mode=p&postal=Ballymena",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=378&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=55.070718&lon=-6.514895000000024&treatmenttype=facial&pagenum={0}&mode=s&postal=Balleymoney",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=2760&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.4111521&lon=-5.895400800000061&treatmenttype=facial&pagenum={0}&mode=p&postal=Ballyahinch",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=7362&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.3510361&lon=-6.2670201999999335&treatmenttype=facial&pagenum={0}&mode=p&postal=Banbridghe",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=6612&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.5972686&lon=-5.930108799999971&treatmenttype=facial&pagenum={0}&mode=p&postal=Belfast",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=2124&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.7210869&lon=-5.791205300000001&treatmenttype=facial&pagenum={0}&mode=p&postal=Carrickfergus",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=8540&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.5186343&lon=-5.88813319999997&treatmenttype=facial&pagenum={0}&mode=p&postal=Carryduff",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=3612&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.5367057&lon=-6.703609599999936&treatmenttype=facial&pagenum={0}&mode=p&postal=Coalisland",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=6409&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=55.1319935&lon=-6.668451399999981&treatmenttype=facial&pagenum={0}&mode=s&postal=Coleraine",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=1327&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.550444&lon=-5.745668000000023&treatmenttype=facial&pagenum={0}&mode=p&postal=Comber",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=4073&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.6458606&lon=-6.74514929999998&treatmenttype=facial&pagenum={0}&mode=p&postal=Cookstown",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=2642&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.4481176&lon=-6.3875785999999835&treatmenttype=facial&pagenum={0}&mode=p&postal=Craigavon",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=390&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=53.344104&lon=-6.267493699999932&trereatmenttype=facial&pagenum={0}&mode=p&postal=Donaghadee",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=8742&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.3239241&lon=-5.703051200000004&treatmenttype=facial&pagenum={0}&mode=p&postal=Downpatrick",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=7025&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.4165302&lon=-6.1488656999999876&treatmenttype=facial&pagenum={0}&mode=p&postal=Dromore",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=4761&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.5954547&lon=-5.797763099999997&treatmenttype=facial&pagenum={0}&mode=p&postal=Dundonald",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=4714&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.5028522&lon=-6.769568299999946&treatmenttype=facial&pagenum={0}&mode=p&postal=Dungannon",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=4731&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=53.2737969&lon=-9.051779899999929&treatmenttype=facial&pagenum={0}&mode=s&postal=Galway",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=6071&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.0630735&lon=-6.006977900000038&treatmenttype=facial&pagenum={0}&mode=p&postal=Kilkeel",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=9872&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=52.6638571&lon=-8.626772599999981&treatmenttype=facial&pagenum={0}&mode=s&postal=Limerick",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=6443&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.8551031&lon=-5.811254500000018&treatmenttype=facial&pagenum={0}&mode=p&postal=Larne",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=7766&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=55.0508545&lon=-6.95053699999994&treatmenttype=facial&pagenum={0}&mode=s&postal=Limavady",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=9822&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.510893&lon=-6.042726000000016&treatmenttype=facial&pagenum={0}&mode=p&postal=Lisburn",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=6303&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.4581592&lon=-6.322846900000059&treatmenttype=facial&pagenum={0}&mode=p&postal=Lurgan",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=1735&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.7554017&lon=-6.606028599999945&treatmenttype=facial&pagenum={0}&mode=p&postal=Magherafelt",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=5833&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.842824&lon=-6.667730600000027&treatmenttype=facial&pagenum={0}&mode=p&postal=Maghera",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=3797&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.9778404&lon=-1.612916499999983&treatmenttype=facial&pagenum={0}&mode=p&postal=Newcastle",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=1129&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.1780417&lon=-6.335768700000017&treatmenttype=facial&pagenum={0}&mode=p&postal=Newry",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=3154&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.684823&lon=-5.965868499999942&treatmenttype=facial&pagenum={0}&mode=p&postal=Netwownabbey",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=1277&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.5950158&lon=-5.7031085999999505&treatmenttype=facial&pagenum={0}&mode=p&postal=Newtownards",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=3250&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.6003046&lon=-7.298401900000044&treatmenttype=facial&pagenum={0}&mode=s&postal=Omagh",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=3442&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.4207102&lon=-6.443767200000025&treatmenttype=facial&pagenum={0}&mode=p&postal=Portadown",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=1461&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=55.1991046&lon=-6.654067199999986&treatmenttype=facial&pagenum={0}&mode=s&postal=Portrush",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=8369&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=55.1873838&lon=-6.719849999999951&treatmenttype=facial&pagenum={0}&mode=s&postal=Portstewart",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=6757&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=53.700178&lon=-6.713522300000022&treatmenttype=facial&pagenum={0}&mode=p&postal=Randalstown",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=9991&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.8234317&lon=-7.4683738999999605&treatmenttype=facial&pagenum={0}&mode=s&postal=Strabane",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=6270&sessionid=0d32285f-1e67-4c83-b897-55624084b9fd&radius=40&lat=54.0989022&lon=-6.249412200000052&treatmenttype=facial&pagenum={0}&mode=p&postal=Warrenpoint"
        //        };

        //private String[] _URLs = {"http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=3373&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.7133822&lon=-6.216760900000054&treatmenttype=facial&pagenum={0}&mode=p&postal=Antrim",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=6603&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.3475392&lon=-6.656108200000062&treatmenttype=facial&pagenum={0}&mode=p&postal=Armagh",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=4557&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.7518736&lon=-6.002596600000061&treatmenttype=facial&pagenum={0}&mode=p&postal=Ballyvlare",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=9353&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.8631169&lon=-6.27834299999995&treatmenttype=facial&pagenum={0}&mode=p&postal=Ballymena",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=378&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=55.070718&lon=-6.514895000000024&treatmenttype=facial&pagenum={0}&mode=s&postal=Balleymoney",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=2760&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.4111521&lon=-5.895400800000061&treatmenttype=facial&pagenum={0}&mode=p&postal=Ballyahinch",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=7362&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.3510361&lon=-6.2670201999999335&treatmenttype=facial&pagenum={0}&mode=p&postal=Banbridghe",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=6612&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.5972686&lon=-5.930108799999971&treatmenttype=facial&pagenum={0}&mode=p&postal=Belfast",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=2124&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.7210869&lon=-5.791205300000001&treatmenttype=facial&pagenum={0}&mode=p&postal=Carrickfergus",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=8540&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.5186343&lon=-5.88813319999997&treatmenttype=facial&pagenum={0}&mode=p&postal=Carryduff",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=3612&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.5367057&lon=-6.703609599999936&treatmenttype=facial&pagenum={0}&mode=p&postal=Coalisland",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=6409&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=55.1319935&lon=-6.668451399999981&treatmenttype=facial&pagenum={0}&mode=s&postal=Coleraine",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=1327&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.550444&lon=-5.745668000000023&treatmenttype=facial&pagenum={0}&mode=p&postal=Comber",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=4073&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.6458606&lon=-6.74514929999998&treatmenttype=facial&pagenum={0}&mode=p&postal=Cookstown",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=2642&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.4481176&lon=-6.3875785999999835&treatmenttype=facial&pagenum={0}&mode=p&postal=Craigavon",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=7747&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.6405797&lon=-5.534846199999947&treatmenttype=facial&pagenum={0}&mode=p&postal=Donaghadee",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=8742&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.3239241&lon=-5.703051200000004&treatmenttype=facial&pagenum={0}&mode=p&postal=Downpatrick",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=7025&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.4165302&lon=-6.1488656999999876&treatmenttype=facial&pagenum={0}&mode=p&postal=Dromore",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=4761&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.5954547&lon=-5.797763099999997&treatmenttype=facial&pagenum={0}&mode=p&postal=Dundonald",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=4714&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.5028522&lon=-6.769568299999946&treatmenttype=facial&pagenum={0}&mode=p&postal=Dungannon",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=4731&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=53.2737969&lon=-9.051779899999929&treatmenttype=facial&pagenum={0}&mode=s&postal=Galway",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=6071&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.0630735&lon=-6.006977900000038&treatmenttype=facial&pagenum={0}&mode=p&postal=Kilkeel",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=9872&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=52.6638571&lon=-8.626772599999981&treatmenttype=facial&pagenum={0}&mode=s&postal=Limerick",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=6443&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.8551031&lon=-5.811254500000018&treatmenttype=facial&pagenum={0}&mode=p&postal=Larne",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=7766&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=55.0508545&lon=-6.95053699999994&treatmenttype=facial&pagenum={0}&mode=s&postal=Limavady",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=9822&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.510893&lon=-6.042726000000016&treatmenttype=facial&pagenum={0}&mode=p&postal=Lisburn",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=6303&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.4581592&lon=-6.322846900000059&treatmenttype=facial&pagenum={0}&mode=p&postal=Lurgan",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=1735&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.7554017&lon=-6.606028599999945&treatmenttype=facial&pagenum={0}&mode=p&postal=Magherafelt",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=5833&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.842824&lon=-6.667730600000027&treatmenttype=facial&pagenum={0}&mode=p&postal=Maghera",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=3797&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.9778404&lon=-1.612916499999983&treatmenttype=facial&pagenum={0}&mode=p&postal=Newcastle",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=1129&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.1780417&lon=-6.335768700000017&treatmenttype=facial&pagenum={0}&mode=p&postal=Newry",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=3154&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.684823&lon=-5.965868499999942&treatmenttype=facial&pagenum={0}&mode=p&postal=Netwownabbey",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=1277&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.5950158&lon=-5.7031085999999505&treatmenttype=facial&pagenum={0}&mode=p&postal=Newtownards",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=3250&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.6003046&lon=-7.298401900000044&treatmenttype=facial&pagenum={0}&mode=s&postal=Omagh",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=3442&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.4207102&lon=-6.443767200000025&treatmenttype=facial&pagenum={0}&mode=p&postal=Portadown",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=1461&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=55.1991046&lon=-6.654067199999986&treatmenttype=facial&pagenum={0}&mode=s&postal=Portrush",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=8369&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=55.1873838&lon=-6.719849999999951&treatmenttype=facial&pagenum={0}&mode=s&postal=Portstewart",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=6757&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=53.700178&lon=-6.713522300000022&treatmenttype=facial&pagenum={0}&mode=p&postal=Randalstown",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=9991&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.8234317&lon=-7.4683738999999605&treatmenttype=facial&pagenum={0}&mode=s&postal=Strabane",
        //                            "http://www.juvedermultra.co.uk/_layouts/Rosetta/clinic_locator.ashx?uniq=6270&sessionid=6b492a23-795c-46a3-af89-016a31abd2ad&radius=40&lat=54.0989022&lon=-6.249412200000052&treatmenttype=facial&pagenum={0}&mode=p&postal=Warrenpoint"
        //        };

        #endregion

        #region URLS of NetherLands
        /// <summary>
        /// URLs of Netherlands
        /// http://www.juvedermultra.nl/ClinicLocator/Pages/ClinicLocator.aspx
        /// </summary>
        //private String[] _URLs = {  "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=39&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=9&lat=52.632281&lon=4.750806&treatmenttype=facial&pagenum={0}&mode=s&postal=Alkmaar&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=1604&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=52.1276577&lon=4.6688508&treatmenttype=facial&pagenum={0}&mode=p&postal=Alphen%20aan%20den%20Rijn",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=6992&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=52.1561113&lon=5.3878266&treatmenttype=facial&pagenum={0}&mode=p&postal=Amersfoort",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=1591&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=52.3&lon=4.87&treatmenttype=facial&pagenum={0}&mode=p&postal=Amstelveen",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=4817&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=52.3730556&lon=4.8922222&treatmenttype=facial&pagenum={0}&mode=p&postal=Amsterdam",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=7653&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=52.2098344&lon=5.9629478&treatmenttype=facial&pagenum={0}&mode=p&postal=Apeldoorn",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=2838&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=53.3206783&lon=6.8544218&treatmenttype=facial&pagenum={0}&mode=s&postal=Appingedam",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=7028&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=52.2098344&lon=5.9629478&treatmenttype=facial&pagenum={0}&mode=p&postal=Apeldoorn",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=5155&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=53.3206783&lon=6.8544218&treatmenttype=facial&pagenum={0}&mode=s&postal=Appingedam&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=8311&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=51.9851034&lon=5.8987296&treatmenttype=facial&pagenum={0}&mode=p&postal=Arnhem",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=4151&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=53.0009135&lon=6.5459814&treatmenttype=facial&pagenum={0}&mode=s&postal=Assen%20Coevorden&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=3863&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=51.4945758&lon=4.2871622&treatmenttype=facial&pagenum={0}&mode=s&postal=Bergen%20op%20Zoom&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=3653&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=53.065479&lon=5.519828&treatmenttype=facial&pagenum={0}&mode=s&postal=Bolsward&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=3633&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=51.5748068&lon=4.7748161&treatmenttype=facial&pagenum={0}&mode=s&postal=Breda",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=4752&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=51.908928&lon=5.330977&treatmenttype=facial&pagenum={0}&mode=s&postal=Buren",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=1071&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=51.95&lon=5.2166667&treatmenttype=facial&pagenum={0}&mode=p&postal=Culemborg",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=6893&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=52.009507&lon=4.360515&treatmenttype=facial&pagenum={0}&mode=p&postal=Delft",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=6694&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=53.331643&lon=6.906998&treatmenttype=facial&pagenum={0}&mode=s&postal=Delfzijl",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=9208&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=52.935304&lon=4.783113&treatmenttype=facial&pagenum={0}&mode=s&postal=Den%20Helder&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=1357&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=52.25446&lon=6.160247&treatmenttype=facial&pagenum={0}&mode=p&postal=Deventer",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=9315&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=51.9666667&lon=6.3&treatmenttype=facial&pagenum={0}&mode=p&postal=Doetinchem",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=2351&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=53.3255453&lon=6.0001461&treatmenttype=facial&pagenum={0}&mode=s&postal=Dokkum&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=793&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=51.797387&lon=4.6734789&treatmenttype=facial&pagenum={0}&mode=s&postal=Dordrecht&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=5518&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=53.106716&lon=6.097673&treatmenttype=facial&pagenum={0}&mode=s&postal=Drachten&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=3074&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=52.51265&lon=5.0493735&treatmenttype=facial&pagenum={0}&mode=p&postal=Edam",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=3725&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=51.4536672&lon=3.5709125&treatmenttype=facial&pagenum={0}&mode=s&postal=Flushing",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=7253&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=53.188459&lon=5.540456&treatmenttype=facial&pagenum={0}&mode=s&postal=Franeker",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=5537&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=51.7023659&lon=4.8499781&treatmenttype=facial&pagenum={0}&mode=s&postal=Geertruidenberg&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=9744&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=50.96912&lon=5.822895&treatmenttype=facial&pagenum={0}&mode=s&postal=Geleen&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=2542&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=51.5046455&lon=3.8911304&treatmenttype=facial&pagenum={0}&mode=s&postal=Goes&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=9231&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=51.834326&lon=4.969423&treatmenttype=facial&pagenum={0}&mode=s&postal=Gorinchem&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=2839&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=52.013859&lon=4.70979&treatmenttype=facial&pagenum={0}&mode=p&postal=Gouda",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=954&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=51.7591667&lon=5.7383333&treatmenttype=facial&pagenum={0}&mode=p&postal=Grave",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=6393&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=52.0341436&lon=6.6271781&treatmenttype=facial&pagenum={0}&mode=s&postal=Groenlo",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=7261&sessionid=97f32189-93d0-4ebb-a934-5a3e61888ba9&radius=25&lat=53.2193835&lon=6.5665018&treatmenttype=facial&pagenum={0}&mode=s&postal=Groningen",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=5350&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=9&lat=52.3802778&lon=4.6405556&treatmenttype=facial&pagenum={0}&mode=s&postal=Haarlem&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=9774&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=9&lat=52.34795&lon=5.62091&treatmenttype=facial&pagenum={0}&mode=s&postal=Harderwijk&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=6146&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=53.1595127&lon=5.4324789&treatmenttype=facial&pagenum={0}&mode=s&postal=Harlingen",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=6403&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.4739306&lon=6.0681758&treatmenttype=facial&pagenum={0}&mode=s&postal=Hattem&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=449&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.9565&lon=5.9274&treatmenttype=facial&pagenum={0}&mode=s&postal=Heerenveen&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=28&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.668&lon=4.841&treatmenttype=facial&pagenum={0}&mode=p&postal=Heerhugowaard",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=5927&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=50.8881742&lon=5.9794988&treatmenttype=facial&pagenum={0}&mode=s&postal=Heerlen&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=5377&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=51.4019714&lon=5.7452183&treatmenttype=facial&pagenum={0}&mode=s&postal=Helmond%20Heusden",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=2470&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.2529637&lon=6.7928589&treatmenttype=facial&pagenum={0}&mode=s&postal=Hengelo",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=9791&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.2233305&lon=5.177503&treatmenttype=facial&pagenum={0}&mode=p&postal=Hilversum",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=3607&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=53.00903&lon=5.620298&treatmenttype=facial&pagenum={0}&mode=s&postal=IJlst",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=9213&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=50.8666667&lon=6.0666667&treatmenttype=facial&pagenum={0}&mode=s&postal=Kerkrade",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=3305&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.2461142&lon=5.229347&treatmenttype=facial&pagenum={0}&mode=p&postal=Laren",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=6381&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.0120583&lon=5.4295484&treatmenttype=facial&pagenum={0}&mode=p&postal=Leersum",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=2454&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=53.2036102&lon=5.8007953&treatmenttype=facial&pagenum={0}&mode=s&postal=Leeuwarden",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=4761&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.1603216&lon=4.4939262&treatmenttype=facial&pagenum={0}&mode=p&postal=Leiden",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=8046&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.51273&lon=5.47214&treatmenttype=facial&pagenum={0}&mode=p&postal=Lelystad",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=7427&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=50.8513682&lon=5.6909725&treatmenttype=facial&pagenum={0}&mode=s&postal=Maastricht&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=4878&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.7666667&lon=5.1&treatmenttype=facial&pagenum={0}&mode=s&postal=Medemblik&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=3792&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.331997&lon=5.064644&treatmenttype=facial&pagenum={0}&mode=p&postal=Muiden",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=3071&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.29839&lon=5.159079&treatmenttype=facial&pagenum={0}&mode=p&postal=Naarden",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=2582&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.03&lon=5.1&treatmenttype=facial&pagenum={0}&mode=p&postal=Nieuwegein",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=8695&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.2202544&lon=5.4893946&treatmenttype=facial&pagenum={0}&mode=p&postal=Nijkerk",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=1967&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=51.842867&lon=5.854622&treatmenttype=facial&pagenum={0}&mode=p&postal=Nijmegen",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=990&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.3116551&lon=6.9268283&treatmenttype=facial&pagenum={0}&mode=s&postal=Oldenzaal&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=7367&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=51.6390404&lon=4.8617369&treatmenttype=facial&pagenum={0}&mode=s&postal=Oosterhout&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=3897&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.505&lon=4.9641667&treatmenttype=facial&pagenum={0}&mode=p&postal=Purmerend",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=9874&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=51.794294&lon=5.64916&treatmenttype=facial&pagenum={0}&mode=p&postal=Ravenstein",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=66&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=51.192442&lon=5.994695&treatmenttype=facial&pagenum={0}&mode=s&postal=Roermond&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=2872&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=51.532135&lon=4.461994&treatmenttype=facial&pagenum={0}&mode=s&postal=Roosendaal&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=1348&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=51.924216&lon=4.481776&treatmenttype=facial&pagenum={0}&mode=p&postal=Rotterdam",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=4576&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.787747&lon=4.797934&treatmenttype=facial&pagenum={0}&mode=s&postal=Schagen&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=5879&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=50.9984052&lon=5.8691186&treatmenttype=facial&pagenum={0}&mode=s&postal=Sittard&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=6237&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.3385948&lon=4.7983068&treatmenttype=facial&pagenum={0}&mode=p&postal=Sloten",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=2777&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=53.0309152&lon=5.661613&treatmenttype=facial&pagenum={0}&mode=s&postal=Sneek",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=3744&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=51.8413&lon=4.331841&treatmenttype=facial&pagenum={0}&mode=s&postal=Spijkenisse&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=2803&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.882339&lon=5.366147&treatmenttype=facial&pagenum={0}&mode=s&postal=Stavoren",	
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=4196&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=51.3322854&lon=3.8324265&treatmenttype=facial&pagenum={0}&mode=s&postal=Terneuzen",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=3245&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=52.0698576&lon=4.2911114&treatmenttype=facial&pagenum={0}&mode=p&postal=The%20Hague",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=2105&sessionid=1486e586-bcc2-4e4f-8c12-04b0184bf1e2&radius=25&lat=51.1626128&lon=5.8427213&treatmenttype=facial&pagenum={0}&mode=s&postal=Thorn",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=7788&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=51.8876176&lon=5.4278765&treatmenttype=facial&pagenum={0}&mode=p&postal=Tiel",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=4383&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=51.571095&lon=5.068817&treatmenttype=facial&pagenum={0}&mode=s&postal=Tilburg",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=9621&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=52.0901422&lon=5.1096649&treatmenttype=facial&pagenum={0}&mode=p&postal=Utrecht",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=2688&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=50.8644444&lon=5.8316667&treatmenttype=facial&pagenum={0}&mode=s&postal=Valkenburg%20aan%20de%20Geul",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=2045&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=52.0263009&lon=5.5544309&treatmenttype=facial&pagenum={0}&mode=p&postal=Veenendaal",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=631&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=51.545192&lon=3.669613&treatmenttype=facial&pagenum={0}&mode=s&postal=Veere&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=9198&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=51.6894911&lon=5.0582397&treatmenttype=facial&pagenum={0}&mode=s&postal=Waalwijk&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=9328&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=51.9691868&lon=5.6653948&treatmenttype=facial&pagenum={0}&mode=p&postal=Wageningen",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=1732&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=51.252171&lon=5.70457&treatmenttype=facial&pagenum={0}&mode=s&postal=Weert&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=4195&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=52.3080507&lon=5.0406217&treatmenttype=facial&pagenum={0}&mode=p&postal=Weesp",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=1534&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=53.1424984&lon=7.0367877&treatmenttype=facial&pagenum={0}&mode=s&postal=Winschoten&tier=a",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=5650&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=52.980533&lon=5.447116&treatmenttype=facial&pagenum={0}&mode=s&postal=Workum",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=2301&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=52.442161&lon=4.810628&treatmenttype=facial&pagenum={0}&mode=p&postal=Zaanstad",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=8716&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=51.8071348&lon=5.2495747&treatmenttype=facial&pagenum={0}&mode=s&postal=Zaltbommel",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=8280&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=52.091195&lon=5.241208&treatmenttype=facial&pagenum={0}&mode=p&postal=Zeist",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=125&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=51.6500689&lon=3.9183674&treatmenttype=facial&pagenum={0}&mode=s&postal=Zierikzee",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=7541&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=52.0611111&lon=4.4933333&treatmenttype=facial&pagenum={0}&mode=p&postal=Zoetermeer",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=8333&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=52.1333333&lon=6.2&treatmenttype=facial&pagenum={0}&mode=p&postal=Zutphen",
        //                            "http://www.juvedermultra.nl/_layouts/Rosetta/clinic_locator.ashx?uniq=4899&sessionid=f94cbd4b-7d8d-463b-9874-6b11c612c767&radius=25&lat=52.5129402&lon=6.1071523&treatmenttype=facial&pagenum={0}&mode=s&postal=Zwolle" 
        //                        };
        #endregion

        #region URLs of Germany
        //private String[] _URLs = {  "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=5888&sessionid=62ec6c18-5883-42a3-9118-2fe214c302a1&radius=40&lat=48.3654574&lon=10.8947684&treatmenttype=facial&pagenum={0}&mode=p&postal=Augsburg",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=1588&sessionid=62ec6c18-5883-42a3-9118-2fe214c302a1&radius=40&lat=50.775466&lon=6.081478&treatmenttype=facial&pagenum={0}&mode=p&postal=Aachen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=3085&sessionid=62ec6c18-5883-42a3-9118-2fe214c302a1&radius=40&lat=52.5234051&lon=13.4113999&treatmenttype=facial&pagenum={0}&mode=p&postal=Berlin",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=8979&sessionid=62ec6c18-5883-42a3-9118-2fe214c302a1&radius=40&lat=53.074981&lon=8.807081&treatmenttype=facial&pagenum={0}&mode=s&postal=Bremen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=9286&sessionid=62ec6c18-5883-42a3-9118-2fe214c302a1&radius=40&lat=51.482901&lon=7.21181&treatmenttype=facial&pagenum={0}&mode=p&postal=Bochum",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=8548&sessionid=62ec6c18-5883-42a3-9118-2fe214c302a1&radius=40&lat=52.0230618&lon=8.5330723&treatmenttype=facial&pagenum={0}&mode=p&postal=Bielefeld",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=2429&sessionid=62ec6c18-5883-42a3-9118-2fe214c302a1&radius=40&lat=50.7327045&lon=7.0963113&treatmenttype=facial&pagenum={0}&mode=p&postal=Bonn",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=3158&sessionid=62ec6c18-5883-42a3-9118-2fe214c302a1&radius=40&lat=52.2641478&lon=10.5263803&treatmenttype=facial&pagenum={0}&mode=p&postal=Braunschweig",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=7928&sessionid=62ec6c18-5883-42a3-9118-2fe214c302a1&radius=40&lat=51.522229&lon=6.924209&treatmenttype=facial&pagenum={0}&mode=p&postal=Bottrop",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=713&sessionid=62ec6c18-5883-42a3-9118-2fe214c302a1&radius=40&lat=53.5419399&lon=8.5780378&treatmenttype=facial&pagenum={0}&mode=s&postal=Bremerhaven",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=3652&sessionid=62ec6c18-5883-42a3-9118-2fe214c302a1&radius=40&lat=50.9917694&lon=7.1364837&treatmenttype=facial&pagenum={0}&mode=p&postal=Bergisch%20Gladbach",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=9589&sessionid=62ec6c18-5883-42a3-9118-2fe214c302a1&radius=40&lat=51.5120542&lon=7.4635729&treatmenttype=facial&pagenum={0}&mode=p&postal=Dortmund",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=8654&sessionid=62ec6c18-5883-42a3-9118-2fe214c302a1&radius=40&lat=51.2249429&lon=6.7756524&treatmenttype=facial&pagenum={0}&mode=p&postal=D%C3%BCsseldorf",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=6229&sessionid=62ec6c18-5883-42a3-9118-2fe214c302a1&radius=40&lat=51.4351458&lon=6.7626911&treatmenttype=facial&pagenum={0}&mode=p&postal=Duisburg",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=2725&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=51.0509912&lon=13.7336335&treatmenttype=facial&pagenum={0}&mode=s&postal=Dresden",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=1258&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=49.8724245&lon=8.6508574&treatmenttype=facial&pagenum={0}&mode=p&postal=Darmstadt",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=5083&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=50.7998461&lon=6.486958&treatmenttype=facial&pagenum={0}&mode=p&postal=D%C3%BCren",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=1184&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=51.8388779&lon=12.2451591&treatmenttype=facial&pagenum={0}&mode=s&postal=Dessau",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=6193&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=51.4579352&lon=7.0148281&treatmenttype=facial&pagenum={0}&mode=p&postal=Essen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=5747&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=50.9737346&lon=11.0223989&treatmenttype=facial&pagenum={0}&mode=s&postal=Erfurt",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=2629&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=49.599937&lon=11.0063&treatmenttype=facial&pagenum={0}&mode=s&postal=Erlangen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=5147&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=48.741097&lon=9.308052&treatmenttype=facial&pagenum={0}&mode=s&postal=Esslingen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=8801&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=50.1115118&lon=8.6805059&treatmenttype=facial&pagenum={0}&mode=p&postal=Frankfurt",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=2981&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=47.9971865&lon=7.8537668&treatmenttype=facial&pagenum={0}&mode=s&postal=Freiburg",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=7755&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=49.4772463&lon=10.9897065&treatmenttype=facial&pagenum={0}&mode=s&postal=F%C3%BCrth",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=9989&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=51.5115316&lon=7.0930303&treatmenttype=facial&pagenum={0}&mode=p&postal=Gelsenkirchen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=8710&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=51.532605&lon=9.928442&treatmenttype=facial&pagenum={0}&mode=s&postal=G%C3%B6ttingen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=5653&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=50.880385&lon=12.081214&treatmenttype=facial&pagenum={0}&mode=s&postal=Gera",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=8288&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=51.9049057&lon=8.3927497&treatmenttype=facial&pagenum={0}&mode=p&postal=G%C3%BCtersloh",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=1423&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=53.5538148&lon=9.9915752&treatmenttype=facial&pagenum={0}&mode=p&postal=Hamburg",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=8658&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=52.3720683&lon=9.7356861&treatmenttype=facial&pagenum={0}&mode=p&postal=Hannover",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=4746&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=51.482166&lon=11.965814&treatmenttype=facial&pagenum={0}&mode=s&postal=Halle",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=3978&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=51.3623128&lon=7.4631725&treatmenttype=facial&pagenum={0}&mode=p&postal=Hagen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=4867&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=51.680386&lon=7.817429&treatmenttype=facial&pagenum={0}&mode=p&postal=Hamm",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=4679&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=51.5385227&lon=7.2192587&treatmenttype=facial&pagenum={0}&mode=p&postal=Herne",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=5044&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=49.4018997&lon=8.680285&treatmenttype=facial&pagenum={0}&mode=p&postal=Heidelberg",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=4448&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=49.141598&lon=9.222083&treatmenttype=facial&pagenum={0}&mode=p&postal=Heilbronn",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=6096&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=52.1509&lon=9.951001&treatmenttype=facial&pagenum={0}&mode=p&postal=Hildesheim",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=604&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=50.135407&lon=8.915129&treatmenttype=facial&pagenum={0}&mode=p&postal=Hanau",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=2889&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=48.762145&lon=11.425389&treatmenttype=facial&pagenum={0}&mode=s&postal=Ingolstadt",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=7270&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=51.3729333&lon=7.6992867&treatmenttype=facial&pagenum={0}&mode=p&postal=Iserlohn",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=8818&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=50.9269994&lon=11.5870113&treatmenttype=facial&pagenum={0}&mode=s&postal=Jena",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=2821&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=50.9406645&lon=6.9599115&treatmenttype=facial&pagenum={0}&mode=p&postal=K%C3%B6ln",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=6818&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=49.0080848&lon=8.4037563&treatmenttype=facial&pagenum={0}&mode=p&postal=Karlsruhe",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=8427&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=51.3317042&lon=6.5593539&treatmenttype=facial&pagenum={0}&mode=p&postal=Krefeld",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=8670&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=51.318928&lon=9.49601&treatmenttype=facial&pagenum={0}&mode=s&postal=Kassel",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=6349&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=50.3566962&lon=7.5996166&treatmenttype=facial&pagenum={0}&mode=p&postal=Koblenz",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=3752&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=49.4447102&lon=7.7690305&treatmenttype=facial&pagenum={0}&mode=p&postal=Kaiserslautern",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=8079&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=51.3396731&lon=12.3713639&treatmenttype=facial&pagenum={0}&mode=s&postal=Leipzig",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=8497&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=53.869563&lon=10.687579&treatmenttype=facial&pagenum={0}&mode=p&postal=L%C3%BCbeck",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=4867&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=49.4807317&lon=8.4412828&treatmenttype=facial&pagenum={0}&mode=p&postal=Ludwigshafen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=1418&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=51.0337487&lon=6.9872871&treatmenttype=facial&pagenum={0}&mode=p&postal=Leverkusen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=9487&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=51.618117&lon=7.524524&treatmenttype=facial&pagenum={0}&mode=p&postal=L%C3%BCnen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=369&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=48.901911&lon=9.193265&treatmenttype=facial&pagenum={0}&mode=s&postal=Ludwigsburg",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=240&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=48.1391265&lon=11.5801863&treatmenttype=facial&pagenum={0}&mode=p&postal=M%C3%BCnchen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=8961&sessionid=904a5223-1acd-44c7-9e86-e319e2594bbe&radius=40&lat=49.4846773&lon=8.476724&treatmenttype=facial&pagenum={0}&mode=p&postal=Mannheim",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=1505&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=51.964711&lon=7.628496&treatmenttype=facial&pagenum={0}&mode=p&postal=M%C3%BCnster",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=7550&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=51.191261&lon=6.442066&treatmenttype=facial&pagenum={0}&mode=p&postal=M%C3%B6nchengladbach",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=6789&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=52.130956&lon=11.636701&treatmenttype=facial&pagenum={0}&mode=s&postal=Magdeburg",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=3009&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=49.9951227&lon=8.2674264&treatmenttype=facial&pagenum={0}&mode=p&postal=Mainz",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=3129&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=51.427073&lon=6.886492&treatmenttype=facial&pagenum={0}&mode=p&postal=M%C3%BClheim",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=2085&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=51.4530476&lon=6.6217453&treatmenttype=facial&pagenum={0}&mode=p&postal=Moers",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=6748&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=51.6531811&lon=7.0978069&treatmenttype=facial&pagenum={0}&mode=p&postal=Marl",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=1370&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=52.289987&lon=8.922157&treatmenttype=facial&pagenum={0}&mode=p&postal=Minden",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=5283&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=49.45052&lon=11.08048&treatmenttype=facial&pagenum={0}&mode=s&postal=N%C3%BCrnberg",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=7729&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=51.1984294&lon=6.69529&treatmenttype=facial&pagenum={0}&mode=p&postal=Neuss",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=2775&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=51.4695797&lon=6.8659747&treatmenttype=facial&pagenum={0}&mode=p&postal=Oberhause",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=7396&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=52.267281&lon=8.0531882&treatmenttype=facial&pagenum={0}&mode=p&postal=Osnabr%C3%BCck",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=4716&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=53.1367194&lon=8.2165357&treatmenttype=facial&pagenum={0}&mode=s&postal=Oldenburg",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=8580&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=50.1049197&lon=8.758561&treatmenttype=facial&pagenum={0}&mode=p&postal=Offenbach",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=6778&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=51.715254&lon=8.75213&treatmenttype=facial&pagenum={0}&mode=s&postal=Paderborn",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=194&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=52.3969627&lon=13.0586008&treatmenttype=facial&pagenum={0}&mode=p&postal=Potsdam",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=2358&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=48.8933834&lon=8.7049203&treatmenttype=facial&pagenum={0}&mode=p&postal=Pforzheim",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=4589&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=49.016491&lon=12.100904&treatmenttype=facial&pagenum={0}&mode=s&postal=Regensburg",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=7560&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=51.611287&lon=7.197382&treatmenttype=facial&pagenum={0}&mode=p&postal=Recklinghausen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=5980&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=51.1793042&lon=7.193936&treatmenttype=facial&pagenum={0}&mode=p&postal=Remscheid",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=1352&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=48.490891&lon=9.205842&treatmenttype=facial&pagenum={0}&mode=s&postal=Reutlingen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=5516&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=51.296859&lon=6.847082&treatmenttype=facial&pagenum={0}&mode=p&postal=Ratingen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=2758&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=48.7771056&lon=9.1807688&treatmenttype=facial&pagenum={0}&mode=s&postal=Stuttgart",
        //        @"http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=7907&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=49.2348506&lon=6.9944016&treatmenttype=facial&pagenum={0}&mode=s&postal=Saarbr%C3%BCcken\",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=6982&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=51.172145&lon=7.083391&treatmenttype=facial&pagenum={0}&mode=p&postal=Solingen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=9799&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=52.1522621&lon=10.3310134&treatmenttype=facial&pagenum={0}&mode=p&postal=Salzgitter",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=3761&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=50.873797&lon=8.023407&treatmenttype=facial&pagenum={0}&mode=s&postal=Siegen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=8&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=49.7537424&lon=6.6462511&treatmenttype=facial&pagenum={0}&mode=s&postal=Trier",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=8352&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=48.399623&lon=9.996607&treatmenttype=facial&pagenum={0}&mode=s&postal=Ulm",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=7800&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=51.3388677&lon=7.0427113&treatmenttype=facial&pagenum={0}&mode=p&postal=Velbert",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=2511&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=48.0553902&lon=8.460072&treatmenttype=facial&pagenum={0}&mode=s&postal=Villingen-Schwenningen",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=9968&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=51.255871&lon=7.149985&treatmenttype=facial&pagenum={0}&mode=p&postal=Wuppertal",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=1270&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=50.08408&lon=8.2383918&treatmenttype=facial&pagenum={0}&mode=p&postal=Wiesbaden",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=5583&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=49.794256&lon=9.927489&treatmenttype=facial&pagenum={0}&mode=s&postal=W%C3%BCrzburg",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=2958&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=52.4218204&lon=10.7849799&treatmenttype=facial&pagenum={0}&mode=s&postal=Wolfsburg",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=754&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=51.437475&lon=7.337293&treatmenttype=facial&pagenum={0}&mode=p&postal=Witten",
        //        "http://www.juvedermultra.de/_layouts/Rosetta/clinic_locator.ashx?uniq=5714&sessionid=1c41cdc2-0427-41a0-a630-b007eb856034&radius=40&lat=53.517063&lon=8.119749&treatmenttype=facial&pagenum={0}&mode=s&postal=Wilhelmshaven",
        //    };
        #endregion
        #region URLs of Italy
        //private String[] _URLs = {"http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=690&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=45.5398297&lon=10.2229573&treatmenttype=facial&pagenum={0}&mode=s&postal=Brescia",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=7827&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=45.6949028&lon=9.6699528&treatmenttype=facial&pagenum={0}&mode=p&postal=Bergamo",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=9152&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=37.5024825&lon=15.0878345&treatmenttype=facial&pagenum={0}&mode=s&postal=Catania",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=7944&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=43.7687324&lon=11.2569013&treatmenttype=facial&pagenum={0}&mode=s&postal=Firenze",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=6728&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=44.8378942&lon=11.6204396&treatmenttype=facial&pagenum={0}&mode=p&postal=Ferrara",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=7293&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=44.221229&lon=12.0426869&treatmenttype=facial&pagenum={0}&mode=s&postal=Forli",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=2980&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=44.4070624&lon=8.9339889&treatmenttype=facial&pagenum={0}&mode=s&postal=Genova",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=7311&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=43.551876&lon=10.3080108&treatmenttype=facial&pagenum={0}&mode=s&postal=Livorno",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=7108&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=41.4675967&lon=12.9037&treatmenttype=facial&pagenum={0}&mode=s&postal=Latina",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=1138&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=45.4636889&lon=9.1881408&treatmenttype=facial&pagenum={0}&mode=p&postal=Milano",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=2071&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=45.5840057&lon=9.2730143&treatmenttype=facial&pagenum={0}&mode=p&postal=Monza",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=4273&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=40.8400969&lon=14.2516357&treatmenttype=facial&pagenum={0}&mode=s&postal=Napoli",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=7540&sessionid=9fab26d8-a994-45e8-993a-6d57497cb70f&radius=40&lat=45.4450839&lon=8.618671&treatmenttype=facial&pagenum={0}&mode=s&postal=Novara&tier=a",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=3017&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=38.1156193&lon=13.3613758&treatmenttype=facial&pagenum={0}&mode=s&postal=Palermo",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=2597&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=45.4095683&lon=11.8765886&treatmenttype=facial&pagenum={0}&mode=p&postal=Padova",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=3252&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=43.8796987&lon=11.0963121&treatmenttype=facial&pagenum={0}&mode=s&postal=Prato",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=421&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=44.8078657&lon=10.3295478&treatmenttype=facial&pagenum={0}&mode=s&postal=Parma",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=5358&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=43.1107009&lon=12.389172&treatmenttype=facial&pagenum={0}&mode=s&postal=Perugia",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=6654&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=41.8954656&lon=12.4823243&treatmenttype=facial&pagenum={0}&mode=p&postal=Roma",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=3740&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=44.4157307&lon=12.1965711&treatmenttype=facial&pagenum={0}&mode=s&postal=Ravenna",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=7657&sessionid=9fab26d8-a994-45e8-993a-6d57497cb70f&radius=40&lat=44.0609167&lon=12.5663013&treatmenttype=facial&pagenum={0}&mode=s&postal=Rimini&tier=a",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=4289&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=40.6779567&lon=14.7659122&treatmenttype=facial&pagenum={0}&mode=s&postal=Salerno",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=7413&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=37.0664551&lon=15.2844276&treatmenttype=facial&pagenum={0}&mode=s&postal=Siracusa",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=5873&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=40.727165&lon=8.5584684&treatmenttype=facial&pagenum={0}&mode=s&postal=Sassari",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=5321&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=45.6536295&lon=13.7784072&treatmenttype=facial&pagenum={0}&mode=s&postal=Trieste",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=2692&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=42.5602192&lon=12.6467812&treatmenttype=facial&pagenum={0}&mode=s&postal=Terni",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=581&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=46.0667123&lon=11.1190591&treatmenttype=facial&pagenum={0}&mode=s&postal=Trento",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=9436&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=45.4343363&lon=12.3387844&treatmenttype=facial&pagenum={0}&mode=p&postal=Venezia",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=2037&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=45.4383667&lon=10.9917476&treatmenttype=facial&pagenum={0}&mode=s&postal=Verona",
        //            "http://www.juvedermultraitalian.eu/_layouts/Rosetta/clinic_locator.ashx?uniq=5618&sessionid=1b426e18-0820-4a00-bc27-bd2c9263d7c5&radius=40&lat=45.5459053&lon=11.540307&treatmenttype=facial&pagenum={0}&mode=p&postal=Vicenza"
 
        //                         };
        #endregion

        #region URLs of Sweden
        private String[] _URLs =  { "http://www.juvedermultra.se/_layouts/Rosetta/clinic_locator.ashx?uniq=5656&sessionid=5c5fc0c7-fdec-4305-9c6e-0073d378fb4b&radius=25&lat=57.7209979&lon=12.9402545&treatmenttype=facial&pagenum={0}&mode=s&postal=Bor%C3%A5s",
                            "http://www.juvedermultra.se/_layouts/Rosetta/clinic_locator.ashx?uniq=2603&sessionid=5c5fc0c7-fdec-4305-9c6e-0073d378fb4b&radius=25&lat=59.3664682&lon=16.5084272&treatmenttype=facial&pagenum={0}&mode=s&postal=Eskilstuna",
                            "http://www.juvedermultra.se/_layouts/Rosetta/clinic_locator.ashx?uniq=2452&sessionid=5c5fc0c7-fdec-4305-9c6e-0073d378fb4b&radius=25&lat=57.6969943&lon=11.9865&treatmenttype=facial&pagenum={0}&mode=s&postal=G%C3%B6teborg",
                            "http://www.juvedermultra.se/_layouts/Rosetta/clinic_locator.ashx?uniq=8622&sessionid=5c5fc0c7-fdec-4305-9c6e-0073d378fb4b&radius=25&lat=60.6746161&lon=17.1418309&treatmenttype=facial&pagenum={0}&mode=s&postal=G%C3%A4vle",
                            "http://www.juvedermultra.se/_layouts/Rosetta/clinic_locator.ashx?uniq=4452&sessionid=5c5fc0c7-fdec-4305-9c6e-0073d378fb4b&radius=25&lat=56.0468716&lon=12.6952855&treatmenttype=facial&pagenum={0}&mode=s&postal=Helsingborg",
                            "http://www.juvedermultra.se/_layouts/Rosetta/clinic_locator.ashx?uniq=8662&sessionid=5c5fc0c7-fdec-4305-9c6e-0073d378fb4b&radius=25&lat=55.7028541&lon=13.1929125&treatmenttype=facial&pagenum={0}&mode=s&postal=Lund",
                            "http://www.juvedermultra.se/_layouts/Rosetta/clinic_locator.ashx?uniq=6533&sessionid=5c5fc0c7-fdec-4305-9c6e-0073d378fb4b&radius=25&lat=55.6033306&lon=13.0013029&treatmenttype=facial&pagenum={0}&mode=s&postal=Malm%C3%B6",
                            "http://www.juvedermultra.se/_layouts/Rosetta/clinic_locator.ashx?uniq=5828&sessionid=5c5fc0c7-fdec-4305-9c6e-0073d378fb4b&radius=25&lat=59.3327881&lon=18.0644881&treatmenttype=facial&pagenum={0}&mode=p&postal=Stockholm",
                            "http://www.juvedermultra.se/_layouts/Rosetta/clinic_locator.ashx?uniq=2701&sessionid=5c5fc0c7-fdec-4305-9c6e-0073d378fb4b&radius=25&lat=59.1959473&lon=17.6279523&treatmenttype=facial&pagenum={0}&mode=p&postal=S%C3%B6dert%C3%A4lje",
                            "http://www.juvedermultra.se/_layouts/Rosetta/clinic_locator.ashx?uniq=6559&sessionid=5c5fc0c7-fdec-4305-9c6e-0073d378fb4b&radius=25&lat=59.8581435&lon=17.6445858&treatmenttype=facial&pagenum={0}&mode=s&postal=Uppsala",
                            "http://www.juvedermultra.se/_layouts/Rosetta/clinic_locator.ashx?uniq=607&sessionid=5c5fc0c7-fdec-4305-9c6e-0073d378fb4b&radius=25&lat=59.616462&lon=16.5515162&treatmenttype=facial&pagenum={0}&mode=s&postal=V%C3%A4ster%C3%A5s",
                            "http://www.juvedermultra.se/_layouts/Rosetta/clinic_locator.ashx?uniq=821&sessionid=dded560b-927c-43ca-9ab5-8d364c9e5aa4&radius=25&lat=59.616462&lon=16.5515162&treatmenttype=facial&pagenum={0}&mode=s&postal=V%C3%A4ster%C3%A5s",
                            "http://www.juvedermultra.se/_layouts/Rosetta/clinic_locator.ashx?uniq=5666&sessionid=dded560b-927c-43ca-9ab5-8d364c9e5aa4&radius=25&lat=59.4436804&lon=18.0688858&treatmenttype=facial&pagenum={0}&mode=p&postal=T%C3%A4by"                        
                        };
        #endregion

        public JuvedermUltra(RichTextBox txtStatus) : base(txtStatus)
        {
            
        }
        public override void StartScrapping(string urlFormat)
        {
            //ProcessFile();
            //return;
            for (int i = 0; i < _URLs.Length; i++)
            {
                this.URLFormat =  _URLs[i];                
                processPage();
                UpdateStatusText(String.Format("Creating New Data File {0}", i));
                String fileName = ToExcel(_ExtractedOffices, String.Format("OutputExcel_{0}.xls", i));
                UpdateStatusText(String.Format("Data File Created in:{0}{1}", Environment.NewLine, fileName));
            }
        }
        #region Test Code
        /// <summary>
        /// This is a test method
        /// </summary>
        protected void ProcessFile()
        {
            String sourceFile = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Ottawa.xlsx");
            DataTable dt = ReadExcel(sourceFile);
            DataTable outputDT = new DataTable("Output");
            outputDT.Columns.Add("Category");
            outputDT.Columns.Add("Name");
            outputDT.Columns.Add("Street Address");
            outputDT.Columns.Add("City");
            outputDT.Columns.Add("Province");
            outputDT.Columns.Add("PostalCode");
            outputDT.Columns.Add("Phone");
            outputDT.Columns.Add("Fax");
            outputDT.Columns.Add("Other Telephone");
            outputDT.Columns.Add("Email");
            outputDT.Columns.Add("Web Site");
            outputDT.Columns.Add("Features");
            outputDT.Columns.Add("Remarks");


            foreach (DataRow row in dt.Rows)
            {
                DataRow oRow = outputDT.NewRow();
                oRow["Category"] = row["Category"];
                oRow["Name"] = row["Name"];
                String address = NullHandler.GetString(row["Address"]);
                if (!address.IsNullOrEmpty())
                {
                    String[] parts = address.Split(',');
                    if (parts.Length == 4)
                    {
                        oRow["Street Address"] = parts[0];
                        oRow["City"] = parts[1];
                        oRow["Province"] = parts[2];
                        oRow["PostalCode"] = parts[3];
                    }
                }              
                oRow["Phone"] = row["Phone"];
                oRow["Fax"] = row["Fax"];
                oRow["Other Telephone"] = row["Other Telephone"];
                oRow["Email"] = row["Email"];
                oRow["Web Site"] = row["Web Site"];
                oRow["Features"] = row["Features"];
                oRow["Remarks"] = row["Remarks"];
                outputDT.Rows.Add(oRow);
            }
            String outputFile = DataTableToExcel(outputDT, null, true, "Output_Ottawa.xls");
        }
        #endregion
        private void processPage()
        {
            String completeURL = String.Format(this.URLFormat, 1);
            offices offices = GetPageData(completeURL);
            if(offices != null)
                processOffices(offices);
        }
        private offices GetPageData(String url)
        {
            UpdateStatusText(String.Format("Loading XML from '{0}'", url));
            String xml = base.GetAuthenticatedPageContent(url, ConfigReader.AuthenticationCookieValue);
            if (xml.IsNullOrEmpty())
                UpdateStatusText(String.Format("{0}{0}----------------{0}Unable to Get XML from Following URL: {0}{1}{0}--------------{0}{0}", Environment.NewLine, url));
            else
            {
                System.IO.StringReader stringReader = new System.IO.StringReader(xml);
                System.Xml.XmlTextReader xmlReader = new System.Xml.XmlTextReader(stringReader);
                //System.IO.StreamReader stream = new System.IO.StreamReader(destination);
                System.Xml.Serialization.XmlSerializer xmlSerilizer = new System.Xml.Serialization.XmlSerializer(typeof(offices));
                UpdateStatusText(String.Format("Deserializing XML to object..."));
                offices offices = xmlSerilizer.Deserialize(xmlReader) as offices;
                return offices;
            }
            return null;
        }
        private void processOffices(offices offices)
        {
            if (offices != null)
            {
                //List<offices> extractedOffices = new List<offices>();
                _ExtractedOffices.Add(offices);
                UpdateStatusText(String.Format("Processing Offices..."));
                //Console.WriteLine(offices.servervars);
                //Console.WriteLine(offices.office.Length);
                int totalRecord = offices.servervars.totalresults;
                int pageCount = totalRecord / 10;
                if (totalRecord % 10 > 0)
                    pageCount += 1;

                for (int pageNumber = 2; pageNumber <= pageCount; pageNumber++)
                {
                    //break;
                    String url = String.Format(this.URLFormat, pageNumber);
                    offices newOffices = GetPageData(url);
                    //extractedOffices.Add(newOffices);
                    _ExtractedOffices.Add(newOffices);
                }                
            }
        }

        public override string OutputFile(List<App.Core.Base.Model.BaseEntity> collection, bool addColumnHeader, string outputFileName)
        {
            throw new NotImplementedException();
        }


        #region Output Excel File Generation
        private String ToExcel(List<offices> officesPages, String outputFileName)
        {
            Workbook book = new Workbook();
            Worksheet sheet = book.Worksheets.Add("Sheet1");
            if (officesPages != null && officesPages.Count > 0)
            {              
                WorksheetRow headerRow = sheet.Table.Rows.Add();
                addHeaderRow(headerRow);
                //addHeaderRow(sheet);
                foreach (offices officesPage in officesPages)
                {
                    if (officesPage.office != null)
                    {
                        for (int i = 0; i < officesPage.office.Length; i++)
                        {
                            WorksheetRow row = sheet.Table.Rows.Add();
                            officesOffice office = officesPage.office[i];
                            addDataRow(row, office);
                        }
                    }
                }
            }

            //row.Cells.Add("Hello World");        

            //String fileName = String.Format("{0}.xls", System.Guid.NewGuid().ToString());
            String filePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "OutputExcel"); //HttpContext.Current.Server.MapPath(AppConstants.TEMP_DIRECTORY);            
            if (!System.IO.Directory.Exists(filePath))
                System.IO.Directory.CreateDirectory(filePath);

            filePath = System.IO.Path.Combine(filePath, outputFileName);

            book.Save(filePath);

            return filePath;
        }

        private void addHeaderRow(Worksheet sheet)
        {
        }

        private void addDataRow(WorksheetRow row, officesOffice office)
        {
            row.Cells.Add(office.institutionName);
            row.Cells.Add(office.physicianName);
            row.Cells.Add(office.address);
            row.Cells.Add(office.city);
            row.Cells.Add(office.postal);
            row.Cells.Add(office.contact);
            row.Cells.Add(office.departmentName);
            row.Cells.Add(office.phone);
            row.Cells.Add(office.email);
            row.Cells.Add(office.website);
            
            ///Specialities
            StringBuilder sb = new StringBuilder(10);
            //foreach (officesOfficeSpecialties speciality in office.specialties)
            //{
            //    if (sb.Length == 0)
            //        sb.AppendFormat("{0}", speciality.specialty);
            //    else
            //        sb.AppendFormat(", {0}", speciality.specialty);
            //}
            
            //WorksheetCell cell = new WorksheetCell(sb.ToString());            
            //row.Cells.Add(sb.ToString());           
            //row.Cells.Add(cell);
            row.Cells.Add(office.specialties.specialty == null ? String.Empty : office.specialties.specialty.name);
            sb.Length = 0;
            ///Treatments
            //foreach (officesOfficeTreatment treatment in office.treatments)
            //{
            //    //sb.AppendFormat("{0}{1}", treatment.name, AppConstants.EXCEL_NEW_LINE);
            //    if (sb.Length == 0)
            //        sb.AppendFormat("{0}", treatment.name);
            //    else
            //        sb.AppendFormat(", {0}", treatment.name);
            //}
            //row.Cells.Add(sb.ToString());
            row.Cells.Add(office.treatments.treatment == null ? String.Empty : office.treatments.treatment.name);
            sb.Length = 0;
            ///Products
            //foreach (officesOfficeProduct product in office.products)
            //{
            //    //sb.AppendFormat("{0}{1}", product.name, AppConstants.EXCEL_NEW_LINE);
            //    if (sb.Length == 0)
            //        sb.AppendFormat("{0}", product.name);
            //    else
            //        sb.AppendFormat(", {0}", product.name);
            //}
            //row.Cells.Add(sb.ToString());
            row.Cells.Add(office.products.product == null ? String.Empty : office.products.product.name);
            sb.Length = 0;
            ///Hours
            foreach (officesOfficeHour hour in office.hours)
            {
                //sb.AppendFormat("{0}:{1}{2}", hour.day, hour.time, AppConstants.EXCEL_NEW_LINE);
                if (sb.Length == 0)
                    sb.AppendFormat("{0}:{1}", hour.day, hour.time);
                else
                    sb.AppendFormat(", {0}:{1}", hour.day, hour.time);
            }
            row.Cells.Add(sb.ToString());
            sb.Length = 0;
        }
        private void addHeaderRow(WorksheetRow row)
        {
            //row.Cells.Add("Office");
            row.Cells.Add("Institution Name");
            row.Cells.Add("Physician Name");            
            row.Cells.Add("Address");
            row.Cells.Add("City");
            row.Cells.Add("Postal Code");
            row.Cells.Add("Contact Name");
            row.Cells.Add("Department Name");
            row.Cells.Add("Phone");
            row.Cells.Add("Email");
            row.Cells.Add("Web Site");
            //WorksheetCell cell = new WorksheetCell("Specialties");
            //cell.StyleID.
            row.Cells.Add("Specialties");
            row.Cells.Add("Treatments");
            row.Cells.Add("Products");
            row.Cells.Add("Hours");
        }        
        #endregion
    }
}
